
GO

/****** Object:  Table [dbo].[BugNet_WikiContent]    Script Date: 10/02/2013 23:24:18 ******/


CREATE TABLE [dbo].[BugNet_WikiContent](
	[WikiId] [int] IDENTITY(1,1) NOT NULL,
	[WikiPageId] [int] NOT NULL,
	[ProjectId] [int] NOT NULL,
	[WikiHTML] [nvarchar](max) NOT NULL,
	[WikiText] [nvarchar](max) NOT NULL,
	[DateCreated] [datetime] NOT NULL,
	[UserCreated] [uniqueidentifier] NOT NULL, 
    CONSTRAINT [PK_BugNet_WikiContent] PRIMARY KEY ([WikiId]),
	CONSTRAINT [FK_BugNet_WikiContent_BugNet_Projects] FOREIGN KEY([ProjectId])REFERENCES [dbo].[BugNet_Projects] ([ProjectId]),
	CONSTRAINT [FK_BugNet_WikiContent_BugNet_WikiPageDetails] FOREIGN KEY([WikiPageId])REFERENCES [dbo].[BugNet_WikiPageDetails] ([WikiPageId])
 )
